SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308411 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308411 [ RunTime:0.002949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111855,793735,609949,573953,612975,833014,425549,220968,563508,999064,657135,139699,274482,566161,376571,388476,519795,1017361,211089,81972,662556,328824,874185,658323,798610,765365,714060,971873,341033,818224,266508,333729,412422,880338,28790,963584,437804,653027,386247,1025473,874034,387229,783406,1007148,283623,601103,571428,392786,82396,252842,80796,633003,205481,1020668,960432,80667,609329,613431,373594,651047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]