SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428753 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428753 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522011,464550,298998,669520,328962,1010139,631013,680187,655103,610655,962184,140984,14640,496336,108636,931648,834720,160281,753242,991821,481531,422706,436565,436399,900828,753800,852148,88137,930210,780729,108596,169887,57570,955291,463982,223605,740084,978103,202814,955897,395360,1027919,287328,454920,964373,133572,661173,290968,595145,878442,203688,693583,988023,987747,847026,621002,819272,800308,780444,20732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]