SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418821 LIMIT 1 [ RunTime:0.003722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418821 [ RunTime:0.004137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935638,820254,636100,663053,368009,454523,1009359,151846,361400,902782,1034337,874945,617489,315360,412189,297561,431259,891639,497827,34577,68975,887220,295906,445204,1013346,565201,596450,961127,862132,890631,429143,447199,752228,331496,274757,100314,753851,359706,555570,691789,1014193,501379,343842,506725,280824,209581,1034560,919321,796027,488126,79111,882647,166300,401662,38053,570625,620035,908309,896401,874532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]