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` = 530008 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530008 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257800,211886,796115,76107,844849,148836,350725,1020711,641411,192884,81583,810467,593997,501134,104126,98161,96348,991497,893201,756675,952110,57710,401979,262041,492566,744304,766320,507718,455865,639308,206242,743498,529139,565558,220971,718837,736754,384393,109629,634674,721643,365060,379340,612032,651317,299181,129467,610996,875315,649766,526380,341570,751950,342115,1031054,533046,701644,593908,716019,727691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]