SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547411 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547411 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882184,957903,16851,880125,384988,227572,752426,363425,723338,171592,942996,784141,677890,272949,497340,294060,212014,667273,726555,109390,773944,132112,1042174,957327,120335,1025300,85722,558698,1041027,1012159,75012,81008,10531,792313,614366,266165,963168,791979,734033,285962,858203,1009471,670643,276661,787921,379008,172591,654568,52568,87602,110460,73320,312370,693754,755608,991840,858189,341606,837413,911343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]