SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396106 LIMIT 1 [ RunTime:0.000761s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396106 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497493,882088,510315,435250,611647,706177,384146,426315,443508,891602,485115,128648,706508,979211,271285,223210,1022760,953855,335038,925832,899038,386119,818642,934367,298263,823867,170974,481203,180012,997486,85447,451668,807023,839881,812598,69688,436292,401566,48775,169166,269986,335775,846135,396750,192876,786922,552673,997958,199487,259844,240349,818134,807732,433512,848365,604718,333879,395856,173737,317544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001662s ]