SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002966s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511262 LIMIT 1 [ RunTime:0.002654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511262 [ RunTime:0.004627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427160,723989,357819,747260,1048256,930993,236351,588343,352769,220596,624285,310757,531919,364478,281143,72217,773594,724135,125593,643158,651055,182154,492218,120485,313120,1004595,645150,531204,76556,590564,158924,329384,199083,783731,184908,672180,658778,126048,805624,221889,846170,760347,265393,41547,390192,218652,967817,777311,368814,925054,807142,126005,905882,769024,255089,303362,760547,575470,604379,1021452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001218s ]