SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450716 LIMIT 1 [ RunTime:0.000662s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450716 [ RunTime:0.003647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417891,347257,680251,623656,453567,825420,1012568,340151,491282,938094,136040,210951,93582,100594,898705,184372,891705,625944,915427,851249,596135,295796,949733,486605,749975,385842,69099,265427,582574,757243,742940,356088,466102,546791,85400,385246,85802,254132,185208,47987,394254,981247,215774,723470,916236,511136,223687,989766,310028,366317,1046885,736386,321010,27165,118140,267482,298147,455561,397182,441959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]