SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045781 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045781 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041241,679021,878085,547519,757336,704767,342608,146805,686859,58472,135285,890541,261797,557565,103544,664137,835469,600386,937672,49820,807777,147696,262213,640228,953130,382680,522721,416171,400663,385651,682218,159365,774988,640660,977948,801920,201859,18924,91320,276313,224676,287004,1010953,946033,680181,948343,117681,653861,207103,1005498,451351,749653,654436,157371,883216,233023,213736,575771,223671,414661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]