SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330075 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330075 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457507,425573,848944,863952,1048326,1012446,714829,778220,378769,690711,763229,136724,417476,957284,978728,418997,955381,465201,80411,679351,125875,341554,1034123,260242,563340,356731,549624,798761,314504,77994,128872,340865,857169,538026,995141,782891,972909,256876,706770,1005083,891521,753016,662322,289589,63600,163884,106133,730460,675123,167793,670454,69607,310908,169916,569161,45464,643954,102417,1045697,308754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]