SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351243 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351243 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18032,552501,672790,150614,889052,215033,816982,830042,510701,955923,1043106,325814,740880,346776,326557,283027,22844,602788,652512,310376,118360,588372,820476,1040825,99308,581499,479108,70695,390893,472550,160894,108569,636766,999052,96117,1017489,986631,428122,978492,253806,959636,180485,801331,377609,419752,522435,982607,1044183,816323,902635,264061,473719,16329,484055,637817,982025,688127,792195,703579,606759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]