SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802534 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802534 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341569,569286,1045903,62408,837640,673192,264241,490225,162274,85994,833774,670948,47010,1019925,1000224,64206,35802,122318,948098,709793,791247,495412,776383,106785,261319,754150,357019,765229,101056,836978,730362,483534,60277,1029509,773089,941728,885933,615760,816109,1025479,605922,137219,69461,138987,474263,37765,66858,1008770,946890,897080,798429,754700,196310,808540,1036566,979354,995203,218369,547309,967118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]