SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44310 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44310 [ RunTime:0.002142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267940,757347,997581,271806,279677,1037575,271576,434870,492551,63444,478109,258471,432629,529036,895743,315610,138223,31448,908527,529384,769019,122204,542284,3457,636985,304777,194410,187424,69821,308483,272955,210660,680703,900970,384944,258199,867796,82617,853651,925188,421193,123689,734844,401101,297845,987794,336187,196579,498786,908309,551625,799087,287021,641511,448988,520839,998168,803684,702527,161121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002435s ]