SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 73150 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 73150 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028750,326430,29313,353179,401796,595776,104164,497120,121698,338707,25432,433669,874783,401419,892342,371845,248142,233883,573855,732434,1037981,1025903,70708,688600,625352,851186,364179,1020265,898538,1008223,471129,1026674,519705,518573,676904,424993,419918,674203,104370,408152,740617,700681,668314,866597,520843,105319,14747,190944,633304,498119,673478,1001741,563317,1037626,58405,146735,799214,240691,998021,431269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 73150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 73150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]