SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001850s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010311 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010311 [ RunTime:0.007931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156805,419227,31735,560336,256710,443011,500355,503237,652363,116925,519933,325897,75514,61517,539083,167093,508575,845682,824381,434421,472327,329934,436488,649958,794429,1048520,614528,28922,779020,205606,811063,831565,290227,509426,3583,135422,26822,648017,681844,869584,511732,490736,624929,103773,506116,874764,541786,232305,8086,392308,576477,267471,381337,492203,974803,392074,117428,859317,547889,740826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]