SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562017 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562017 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815797,236776,108794,623071,898296,694433,134659,172364,846687,1019240,400699,739744,251615,305358,295390,630882,98761,225798,760206,953978,757044,881165,390538,232300,203789,199092,189596,869075,338458,485707,729937,185818,429388,614934,1000675,1045852,943145,365198,675853,137668,881378,602391,564843,410390,102601,40488,375583,341333,256106,167245,536034,595707,266024,891175,239579,263577,315910,592323,999052,990533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]