SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419743 LIMIT 1 [ RunTime:0.002045s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419743 [ RunTime:0.003089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5974,852212,734410,988412,317105,332130,166103,384761,596002,671840,515758,642759,217939,319894,924528,735985,747590,853201,118322,812099,760533,580675,317693,595155,430786,145684,603379,786344,365883,528244,725780,852948,1025101,845215,401602,945374,762331,50306,177195,782699,894747,484668,522020,771179,214897,959981,338522,369096,259263,443661,552671,900026,463449,945239,20537,315102,425585,827105,188862,845503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]