SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596101 LIMIT 1 [ RunTime:0.000812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596101 [ RunTime:0.002308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552385,977586,568776,931560,950122,626491,469209,40967,915638,603563,102645,220348,323463,818048,794870,1000869,448255,265304,209936,1006979,853014,36665,141266,851750,499810,905390,32539,151590,291180,218947,1010659,97108,809566,815970,244780,153776,595304,279885,103064,387586,431585,142801,1024010,586621,596053,697940,422490,269644,290648,447603,352422,981037,418587,534925,400391,436549,152654,36840,202468,873472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001654s ]