SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474402 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474402 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284520,381289,902638,488977,110047,201930,415875,503809,773684,3641,813940,745514,159506,799463,955224,316301,410892,314123,470919,196073,861537,265535,981572,65941,352591,664720,544368,810694,38682,318236,1048100,573446,73401,481547,173940,903683,283693,879387,833998,736400,520955,646962,300208,92642,229958,72214,898572,607776,841543,190187,288291,736177,757004,794703,743778,852186,479304,236523,667004,785916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]