SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107729 LIMIT 1 [ RunTime:0.001755s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107729 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003306,1018112,366228,507180,5140,581383,494197,733077,38730,349576,547276,976212,443883,316989,413107,695806,681978,191785,938001,299887,160010,632417,927665,12603,546529,751487,697919,858161,456815,416236,894164,788715,582949,698865,539514,880002,699071,851353,13916,529830,413839,588862,670409,630767,533319,815526,779338,625738,743428,998128,457229,86802,255072,1048871,83046,405469,820552,137006,542586,431578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002547s ]