SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043081 LIMIT 1 [ RunTime:0.001121s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043081 [ RunTime:0.010816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882638,893185,14101,142898,1016947,61434,370935,587648,570648,98224,201049,666768,855011,847798,689270,642291,522071,829164,999612,868849,456922,504146,589470,564911,786024,345659,768390,161618,46628,686499,310838,1011449,140457,560815,858195,602556,147816,847768,150924,610026,87210,1042824,385568,30326,486055,300410,1028714,152683,485911,453714,764608,245435,256033,890030,1006692,926781,507676,44900,167976,532521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]