SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567413 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567413 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577948,648790,243675,324944,525266,717158,404549,5377,840646,574347,933711,478441,907141,400956,55636,177126,129330,112962,90358,1040543,16062,1040942,161222,96033,847380,710565,423117,111518,958919,357605,970216,520107,108068,420701,988676,395513,435072,241963,595393,569514,49516,312095,776861,798618,28042,921073,562908,980467,102064,434373,1003320,273070,211586,547592,572857,302349,253464,132179,636450,961780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001363s ]