SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803621 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803621 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845298,869575,659530,70856,524232,912241,579761,101690,442500,301191,552988,348208,98514,151003,571654,252069,671633,807165,408748,949577,591601,254531,253841,986997,108331,161944,422328,335592,945048,835935,245569,698340,412148,99733,710408,424853,169329,611583,923387,878949,361966,790736,55827,892177,733854,119689,105779,205604,116724,799380,496821,538865,496412,405138,430717,1015711,315802,83704,63249,1018796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]