SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50713 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50713 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707379,868800,1046185,826672,592007,1041281,134869,937582,41588,862262,858845,524864,824975,707334,959085,949089,927738,817882,818994,855411,272532,274669,190440,431325,741205,847455,853066,777058,545423,63768,565711,533833,761084,149848,699732,251207,658930,85931,386389,959150,298942,107882,43493,81587,831785,138701,73820,529876,229321,1001666,948290,638186,358250,142936,915188,423735,562078,122646,187665,962163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]