SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525210 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525210 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61214,755302,470525,114389,299873,638420,309188,566564,247320,246943,464568,319609,511581,828153,463300,395287,184823,259535,882385,683305,808445,1039025,527261,993267,827211,108913,972667,591540,910659,961115,58175,1029863,267798,289102,926150,705468,301200,466091,757454,923986,486881,37336,102929,942876,279770,443818,537109,203536,223295,235381,1042961,852082,661809,337456,1033168,250820,362870,359572,1030428,1018817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]