SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 780009 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 780009 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615304,257497,376907,262847,174709,614858,954888,192666,965343,58122,524721,46211,427424,756645,442301,1024855,267293,790958,1005638,681244,1044721,121407,707159,692137,589750,61848,145265,632468,266763,16569,741499,1028661,369751,417318,782387,974993,699565,894057,823436,987789,642863,448783,609525,536144,463634,238012,349697,542327,3284,772984,1040676,964130,658889,557183,665188,315100,345784,585545,972977,41489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 780009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 780009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]