SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498301 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498301 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461894,195082,590770,225637,634499,707614,102507,399914,843815,628628,604865,729141,806410,269124,800496,850770,1045822,291561,1007271,117345,508132,729038,63741,1008526,74298,1016454,593822,711400,211571,722065,189346,200257,920079,1035547,610639,12354,924394,677682,651123,436052,499033,845460,543043,425847,400444,837412,935389,734059,271062,142678,61063,243235,731844,195020,439054,108961,60468,312669,728758,780250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]