SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028909 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028909 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740581,119273,254348,166094,776088,284234,641172,186012,1037945,568274,61200,306538,242426,131837,677436,441096,527084,265711,279996,990993,1021512,479586,766684,267019,948354,548955,832052,272565,618337,190226,971957,29999,187466,388298,454533,12114,839000,1685,32074,234577,742865,459947,379199,925033,990728,306386,421250,309967,924369,234590,63476,552042,9406,195083,588799,110102,838624,105620,296195,377151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]