SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299610 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299610 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998719,146989,866150,334474,740753,588322,682797,472476,274696,1044391,696444,839254,990449,724287,219635,644745,243753,459819,676214,275630,172258,421536,718779,729053,132472,233441,592008,508098,427521,163591,229314,398025,140082,938817,715965,935293,549736,583979,597835,283173,218677,678881,516265,386917,101540,776244,743502,471194,769650,446132,698653,148914,823105,115396,789468,474209,107567,534103,443064,206849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]