SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518634 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518634 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018097,294660,169580,869083,73415,412683,615575,254053,856307,818211,44597,891767,1014282,134783,257246,221367,429948,784593,202481,902776,920930,39601,146852,399360,227766,268833,1016970,806427,762559,153358,734607,1003725,317329,291062,310379,187159,251481,594743,843155,973675,365236,351806,282873,346581,722895,39093,1048002,291042,448990,1044485,736632,57765,642121,930687,128735,392017,407793,311948,881672,290985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]