SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345613 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345613 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181816,1004584,73654,27470,778613,969025,1027117,565171,448924,213282,66440,813911,626387,434215,512266,530662,467512,527510,221295,981269,986572,555146,153265,809577,724980,960346,435007,951818,152456,18394,968223,802527,912949,139807,765608,1003675,924613,810845,255393,574297,149452,514659,555968,452005,167237,324791,386509,445891,464959,670451,856323,145698,673940,877633,285546,516626,580076,780047,31260,469813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]