SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431743 LIMIT 1 [ RunTime:0.000681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431743 [ RunTime:0.005380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324617,44079,438442,1043497,483273,603320,368488,381389,225803,155777,350947,1022384,589021,928604,367491,680801,414038,276933,157304,625479,788051,307836,114896,408639,419465,813500,451966,163705,337868,993225,213714,580673,921960,1005967,479079,1048150,136686,530705,408906,15600,282127,240012,335878,584287,230643,481637,689974,1032409,395587,807631,89786,1002535,471516,895321,581125,57392,406670,182724,40743,927222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001132s ]