SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610323 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610323 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149692,918174,992443,1045779,668964,157042,217251,99244,545644,232119,68391,36295,77195,726800,236556,922798,685765,460204,326082,936660,397238,465667,765220,407761,252687,855973,661163,25614,543070,1017215,767412,89348,226596,644584,211239,913624,210338,941939,577835,166387,63076,420745,1031532,132289,694906,654843,662904,15065,563851,495718,647691,657731,608085,949591,742104,995771,474727,929655,849841,733628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]