SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406311 LIMIT 1 [ RunTime:0.001177s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406311 [ RunTime:0.003565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174511,296469,521742,456140,53352,788198,500373,271111,762272,425682,36531,723503,603532,833117,868008,443118,578570,178176,543874,578276,986659,701828,283382,603326,818316,926087,483941,690374,232059,614188,585026,587053,206428,943277,563882,900929,22519,319300,943937,305338,482365,114079,136141,154285,701715,450819,230348,790144,248780,199118,55613,940734,824039,594952,271851,435634,108577,37705,982991,133705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]