SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489218 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489218 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674883,190552,963740,145114,152107,18445,231214,360612,637854,911697,486751,406749,1025403,568142,424300,404950,112011,1019724,188201,170522,329375,919578,537562,918496,630037,294043,300787,413157,44159,43724,284098,990082,570205,890804,807559,560689,1013437,463166,885042,603701,301184,124734,124605,623436,592045,496811,811788,169284,154595,794990,266521,794055,201716,787092,298413,758174,252530,558085,903467,628888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]