SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563175 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563175 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185588,435909,498574,1027866,73428,630649,513653,230094,915765,61001,961693,289890,138908,835526,5106,1038940,805868,344141,635653,1029537,934591,40833,288610,922870,1012830,372259,671843,388277,345376,454110,662635,836709,62821,292002,764818,831669,718143,210786,340653,545304,106002,1021121,331906,559589,232661,809227,1047274,447893,156330,650963,728065,435387,142590,719914,153794,160077,947649,434796,27434,91609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002723s ]