SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 614813 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 614813 [ RunTime:0.005548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222540,552358,480320,309788,1002955,331333,794813,69758,913850,934493,113550,813287,575389,659678,219229,344833,110050,159134,596497,506989,843076,894813,540331,240729,384812,904184,618429,1013345,785981,367129,404736,341800,750052,818184,244245,890490,194573,411222,1045283,972802,156153,211224,896648,879054,975281,610671,783107,1023687,760486,217360,646570,179973,224609,299161,537095,1025568,124632,870025,173635,640685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 614813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 614813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000844s ]