SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910210 LIMIT 1 [ RunTime:0.003982s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910210 [ RunTime:0.002769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599011,359098,387597,571453,913559,374819,821361,38813,997271,1014197,223322,262135,241536,1040772,551554,321433,344727,286870,23886,987077,779962,479973,951515,302674,751465,726318,99642,906548,180207,617007,670993,465175,305765,973304,977185,253275,105776,76544,709085,380401,657655,531749,659520,220995,455146,474675,200146,264344,628572,95311,545125,426320,488593,224578,511050,88063,732800,53611,962456,524303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002495s ]