SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309685 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309685 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048667,365968,139826,418341,169815,244672,230305,943851,695509,229231,81597,127900,186046,968984,386131,922505,410670,128403,1020020,500198,19787,913109,47280,780614,182416,875431,507864,321740,482140,388240,949732,511084,335885,451845,60207,472160,75803,164863,621311,993713,154496,866591,450158,788858,309867,271410,216794,638182,549327,120798,363939,395434,1010305,855111,893230,955763,148740,840444,107794,617775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]