SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018522 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018522 [ RunTime:0.004387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237006,105496,166521,773491,996176,76023,187530,464627,194136,836287,402301,318787,634082,861459,769727,79318,907647,456169,39492,1015325,648916,458347,233698,535024,991567,520856,508019,652176,581807,7069,994806,982717,891068,325299,938006,533783,432638,855730,732250,25914,443364,531416,892023,393102,59622,814458,705085,973245,112714,407380,995472,608847,24488,744421,912958,890743,849200,687113,530706,151964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001086s ]