SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580018 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580018 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38934,576254,127316,547990,413405,119515,306192,548440,853276,445340,466,483510,171600,852439,494592,554192,191611,858120,605624,578327,486464,1044924,291623,1040964,680228,992026,71179,812450,284150,211458,481379,807504,848141,757960,471288,1043096,239185,24464,555224,32320,172541,534499,593073,811724,592015,551029,105189,222210,75153,276450,362192,40700,195770,845703,858467,41182,537823,60547,603819,671185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001735s ]