SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506214 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506214 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980033,814047,653229,99507,283219,367741,986067,619573,634419,66374,914013,901046,1020831,324428,673106,759798,436788,572344,720820,365755,508847,807683,803172,800702,425952,996877,798998,815056,407753,136386,934088,1019582,182184,601809,22185,833002,200107,799054,190521,771119,797111,391567,879826,512257,968352,197428,579360,572428,619318,446049,274207,787596,996994,453091,477373,183144,60283,262399,406855,616797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]