SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417491 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417491 [ RunTime:0.003220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438479,191231,639276,1027071,65991,393035,334929,807767,1020032,493028,850464,398922,1043571,751735,502070,799065,468851,144470,731208,971922,246277,286173,632987,662367,245195,735107,482974,771106,493889,390009,616246,502350,932216,10971,127853,335731,956220,187734,576768,1046778,2463,548250,1033684,72284,636783,907323,87888,190272,603551,634792,159412,777079,655962,947301,837635,452109,301591,426257,288970,62659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001704s ]