SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042823 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042823 [ RunTime:0.003491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786367,775152,736062,89011,98186,875019,140542,1033459,726691,39400,766962,849456,1006538,57761,244324,888549,15431,472226,831698,492122,1009706,135114,693756,586034,329446,191437,481092,125088,568287,360629,922267,282733,724200,398411,82601,798343,775892,88023,253030,532732,979296,496025,857620,639954,445,447253,612571,677302,473307,88136,525508,108731,187083,876770,280529,514578,254236,864437,459980,599925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]