SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431012 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431012 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67582,1016920,1004397,826181,598241,286898,493276,746754,155630,66961,1034030,211425,96902,719096,513303,763043,821673,403390,245397,717694,678963,191266,112625,101595,754399,915272,1038497,164461,955766,694328,911029,12073,427801,380664,122797,593161,207467,317845,1781,980276,22966,55817,782771,960743,516705,344418,305337,471545,300579,259280,450419,24172,784848,185081,1014200,934616,879698,319579,233582,807528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]