SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313550 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313550 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040602,317891,609150,161575,268244,797022,430236,530673,785621,59869,20543,1026810,377483,31413,290319,389914,1045711,285481,143262,933768,868527,11933,421377,3135,583715,576645,367797,471389,420793,868259,90300,690625,527285,133965,86724,290439,408810,68652,383578,969637,422660,305528,1017462,702210,755193,73311,471681,628666,950820,683416,637271,860643,503693,541077,896285,94804,482566,1046278,253668,415889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]