SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002042s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59188 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59188 [ RunTime:0.005872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788284,476767,322449,153802,655744,864524,1017097,346280,549371,507318,228446,357529,201895,879913,81400,508580,710319,32838,960270,101991,816594,432913,735217,117248,112479,166168,604929,394683,122050,676089,731803,308891,969644,1024843,398870,171450,286177,42158,666124,587455,849977,324005,656529,490849,783957,993796,666243,754283,728552,464423,902449,985215,388965,24195,352816,38259,117019,62446,519631,951524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]