SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048027 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048027 [ RunTime:0.003587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629610,854873,17372,394867,941726,908994,939352,432458,104944,520643,662892,169668,693478,708240,866727,294383,557853,1032144,444419,530085,780328,465142,575067,397379,390897,997597,713328,907550,674307,711683,611238,962015,608623,402009,196953,225523,856171,405988,452579,1039041,31742,85070,781144,903438,241297,325927,7973,632089,119318,1028093,307156,965922,282600,86674,572002,446385,786563,618917,1036958,793051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]