SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048561 LIMIT 1 [ RunTime:0.001086s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048561 [ RunTime:0.006896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639035,1017209,697940,437291,235808,685242,1042522,425482,276417,873516,547557,306428,684583,27050,898442,480102,437639,281990,522615,907944,592169,824896,100691,223807,861530,594222,498186,250353,945366,473033,52481,308300,60706,888314,1031375,110169,353459,390962,269926,716025,190180,311604,89384,802544,711126,604872,173648,924511,714514,917420,848699,1015856,548606,502269,1028099,882046,204552,1025808,722186,376123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001637s ]