SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001641s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 659246 LIMIT 1 [ RunTime:0.001291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 659246 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000522,197438,51280,648684,845920,882522,1016710,914271,1009353,239517,875816,896764,472610,26428,203201,691938,250789,408405,68121,934982,1001400,527591,1002228,743335,377890,779699,622748,17114,691644,373855,610281,495435,1045656,483050,128902,64587,250400,502406,136481,241035,618701,436930,83620,44582,561229,714044,543480,168420,680228,632733,918124,1047356,311040,388018,648817,593411,657550,136749,584093,311558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 659246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 659246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]