SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265404 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265404 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454913,926568,117957,592549,541363,671374,1010602,369815,196644,931706,420613,939447,306822,25972,48849,939116,165982,768570,762765,916476,521821,705627,442921,1045493,419465,729247,996445,354748,619775,587298,471573,62092,866047,159228,275448,103883,930626,873270,683375,142358,629839,448472,946118,742953,1036131,476349,987485,396975,948832,139639,41883,277012,412537,285213,663039,137393,505454,511558,747887,25743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]