SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017243 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017243 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940830,89139,280921,763399,782879,734769,148135,299801,275238,948008,839042,303437,36537,191798,351131,185493,166051,131178,661359,429114,850986,88401,518493,1011164,134229,282394,840552,769602,461459,835463,966132,562997,189955,51195,224386,1001797,956727,580062,46736,288662,252019,1012850,497606,231512,600507,399115,1036357,486401,69353,648905,379722,128144,577709,1032566,699203,794773,1019837,549687,953144,792594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]