SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419129 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419129 [ RunTime:0.002219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281391,359652,709663,638396,861386,985450,1039809,105854,967039,74856,87887,574763,879494,312761,209908,563782,428971,295317,949773,676292,162684,310962,662508,488968,546228,139859,82128,723908,632469,422837,500055,247236,96679,373253,307290,917804,129979,479548,649172,305780,112910,929146,350709,317569,73349,201772,83318,299457,875603,656058,519531,532599,377257,934761,990337,607016,701784,331162,142053,1042890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]