SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578503 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578503 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339638,8867,521175,659754,408157,753980,149448,1006359,660489,1032305,954126,945649,690093,257269,268461,577658,11461,1046153,291551,175079,233643,856790,184091,1022882,331364,24079,718830,259367,826018,296704,711793,827648,440511,302682,658349,45653,918386,83434,708679,144667,530732,194927,422911,618604,254122,630912,709436,852631,1033739,815914,117748,348735,378565,444032,714069,744019,1005905,797874,239619,806933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]