SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107102 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107102 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433522,1021970,827404,239830,194755,621142,796383,984452,449576,364214,434570,1021632,922220,178405,744020,384407,838517,789968,339717,108051,226122,442427,276333,734110,954868,882800,608567,524213,138312,945231,510015,769820,521868,998364,713186,62406,627454,980938,1010962,495649,646669,736063,33236,445883,455324,195980,548725,51571,231193,983963,110493,707054,597512,981145,305746,377254,757850,193011,342676,450747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]