SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469861 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469861 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639317,384848,108219,708725,42869,317217,986606,67688,594036,702904,66989,758674,439274,156193,696395,369260,554159,616926,603646,687671,859303,908734,580487,619832,401054,202246,655005,615918,360989,484193,800321,265314,119534,49783,365223,190091,441470,266159,174137,671231,160202,66500,180152,613838,1046152,545952,105567,859300,428059,743131,961834,357984,703995,195618,1030585,192028,92832,193841,447261,1034083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]