SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524308 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524308 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420518,241966,154637,1043803,672630,2703,244942,48654,465866,755782,403935,852877,717562,684874,842817,827032,610119,791232,719103,248229,902740,10069,364043,680936,124568,874803,881042,753523,595516,512301,910556,1042661,510492,581772,722905,497934,507052,205868,617912,310640,535455,368725,75900,372108,509968,299381,328676,837149,1019097,1028304,1035409,776223,717121,985759,47465,160775,38356,774321,832100,377858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]