SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423698 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423698 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30906,587483,34824,334432,964214,236627,967393,238271,836785,422947,20992,70361,761178,200917,951310,75000,711997,854384,512830,969721,878967,202214,808121,138436,566629,348293,1025703,738310,1009709,715083,431394,829722,375489,605190,304295,465229,710124,611440,684169,743930,780764,107227,386202,232335,228562,129343,414394,503448,721027,256099,369197,992128,450742,256635,181264,490253,922870,503441,40517,450843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]