SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312801 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312801 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242146,787977,62114,71114,445417,231934,993717,785871,737221,843895,798832,273609,77633,159757,940987,709641,995081,489807,274861,162352,455367,612405,1004850,73911,581681,264611,731181,165054,834174,798022,1016288,200952,661867,268018,810739,771233,357089,1041961,79123,725921,529688,738806,737956,173713,991542,855561,954798,771055,693754,583826,518779,940479,511015,791681,873179,687425,711149,983233,603298,134094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]