SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424733 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424733 [ RunTime:0.007121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434297,407479,370592,1038727,603038,604038,3324,697398,622494,435035,356032,311943,560160,226980,742957,546460,258492,834710,796780,607758,40990,596434,552523,433154,503270,230032,863851,134461,1020925,1019313,518099,86143,766086,551376,990346,383894,202390,474730,736950,633584,681924,536073,558519,639217,454056,706737,972868,892386,802243,297149,394672,330238,256811,101361,636268,520804,376744,781231,314753,899421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]