SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985306 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985306 [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008929,14404,36105,635608,1017420,763626,808804,509996,937472,404436,860607,99846,880798,603058,848457,151215,147061,840883,547355,673919,1013608,91285,963892,449552,235107,183891,983691,247409,1025454,739926,808393,788285,342920,465538,883138,311049,752989,532058,712325,310785,621961,652482,206033,258974,163563,206659,1001442,170519,619707,70142,121765,293880,437935,722628,867744,825604,532089,874478,997489,601148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]