SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417409 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417409 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50486,728617,489470,964279,473245,31064,105506,275545,6773,430418,781592,248628,984145,1040536,309105,894701,383904,772405,1013009,939675,493588,41060,54096,929723,878989,356808,888201,740855,667977,606492,21208,397081,569055,583515,74935,688864,680234,843022,323615,457681,639201,272919,162529,227493,521806,7304,385924,908737,619734,480411,196049,256627,651116,163888,263560,772765,543463,816431,148578,1002733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]