SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475518 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475518 [ RunTime:0.003683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936735,977308,446390,755972,657153,395031,51815,456039,776253,388997,862357,892040,622492,856348,288821,428233,155015,228577,334825,566729,244834,165075,733565,129172,306294,601371,299092,1047280,261520,85479,591848,109159,368363,197008,380020,257151,421970,614083,492526,453724,14311,954516,164279,93193,680103,351671,297618,674135,543508,376943,157980,670007,929467,907608,852202,41169,310297,900998,399830,244263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]