SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391414 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391414 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1212,710449,437563,773910,61665,727166,210038,305037,571203,498762,242081,377461,151002,323337,38828,846472,287587,559736,182352,680169,570119,54065,738925,869868,824202,423708,611681,301150,169424,24356,966540,662820,888121,193616,315720,176494,177037,272873,730360,974008,684968,620643,990429,118468,270755,51385,636834,880029,247683,257685,914083,126753,878294,487078,767324,90684,14361,671625,72366,765027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]