SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198073 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198073 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540438,462922,916075,209336,477508,153006,313460,968536,585559,120609,900782,879996,410723,1019332,931375,926195,290819,68325,109001,537177,806054,921755,658440,597769,110683,288435,883501,475993,435037,297546,533902,12674,127683,716258,453111,832120,817755,1029215,81741,904689,79385,888980,176044,243914,853200,845795,835127,957101,458816,942485,15183,722617,968042,801330,713700,56274,586623,860994,989219,548276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]