SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035940 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035940 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744636,373685,465237,516469,51794,349319,933900,252569,982098,325515,700895,846600,540983,646242,728714,91368,615049,292660,270678,10394,325339,609878,1013795,859509,971016,989619,943525,128925,951832,251753,1021710,383614,316706,795076,552686,398685,842423,530014,855596,125706,276983,447636,313716,57241,287036,420036,1019208,574323,1026817,927585,215175,930624,172395,205902,412782,17506,152096,871174,839934,116626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]